<?php
	include_once("global.php");
	session_start();
	$uid = $_SESSION['name'];
	$smarty->assign("uid",$uid);

	
	//头部
	$sql_select_search = "select K_Name,K_KID from keywordinfo where K_search > '1' limit 0,4";
	$query_select_search = $mysqli->query($sql_select_search);
	while($result_select_search = $query_select_search->fetch_assoc()){
		$assign_search[] = array(	"num"	=>	$result_select_search['K_KID'],
									"name"	=>	$result_select_search['K_Name']);
	}
	$smarty->assign("assign_search",$assign_search);/*热门关键词*/
	
	$sql_select_skeyword = "select K_Name,K_KID from keywordinfo where K_search = '1'";
	$query_select_skeyword = $mysqli->query($sql_select_skeyword);
	while($result_select_skeyword = $query_select_skeyword->fetch_assoc()){
		$assign_skeyword[] = array(	"num"	=>	$result_select_skeyword['K_KID'],
									"name"	=>	$result_select_skeyword['K_Name']);
	}
	$smarty->assign("assign_skeyword",$assign_skeyword);/*搜索框内关键词*/
	
	$sql_select_articlecategory = "select * from categoryinfo limit 0,2";
	$query_select_articlecategory = $mysqli->query($sql_select_articlecategory);
	while($result_select_articlecategory = $query_select_articlecategory->fetch_assoc()){
		$assign_artcategory[] = array (	"id"	=>	$result_select_articlecategory['C_CID'],
										"name"	=>	$result_select_articlecategory['C_Categoryname']);
	}
	$smarty->assign("assign_artcategory",$assign_artcategory);/*导航条*/
	
	$sql_select_countapp = "select * from appinfo";
	$query_select_countapp = $mysqli->query($sql_select_countapp);
	$result_select_countapp = $query_select_countapp->num_rows;
	$assign_countapp = $result_select_countapp;
	$smarty->assign("assign_countapp",$assign_countapp);/*站内APP统计*/
	
	$random = rand(50,$assign_countapp);
	$assign_radnom = $random;
	$smarty->assign("assign_radnom",$assign_radnom);	
	
	//通栏推广位
	$sql_select_banner = "select * from pushinfo where P_Pushid >30";
	$query_select_banner = $mysqli->query($sql_select_banner);
	while($result_select_banner = $query_select_banner->fetch_assoc()){
		$banner_appid = $result_select_banner['P_Pushappid'];
		$banner_apppid = $result_select_banner['P_Pushpid'];
		
		$sql_select_bannerpic = "select * from pictureinfo where P_PID = '$banner_apppid'";
		$query_select_bannerpic = $mysqli->query($sql_select_bannerpic);
		$result_select_bannerpic = $query_select_bannerpic->fetch_assoc();
		
		$sql_select_bannerapp = "select * from appinfo where A_Apptrackid = '$banner_appid'";
		$query_select_bannerapp = $mysqli->query($sql_select_bannerapp);
		$result_select_bannerapp = $query_select_bannerapp->fetch_assoc();
		
		$assign_bannerapp[] = array(	"id"	=>	$banner_appid,
										"name"	=>	$result_select_bannerapp['A_Apptrackname'],
										"url"	=>	"images/".$result_select_bannerpic['P_Name'].".png",);
	}
	$smarty->assign("assign_bannerapp",$assign_bannerapp);/*顶部通栏，首页通栏1，首页通栏2*/
	
	//右侧
	//右侧文章推广
	$sql_select_right = "select P_Pushpid,P_Pushartid from pushinfo where P_Pushid >'18' and P_Pushid < '21'";
	$query_select_right = $mysqli->query($sql_select_right);
	while($result_select_right = $query_select_right->fetch_assoc()){
		$pid = $result_select_right['P_Pushpid'];
		$artid = $result_select_right['P_Pushartid'];

		$sql_select_rightpid = "select P_Name from pictureinfo where P_PID = '$pid'";
		$query_select_rightpid = $mysqli->query($sql_select_rightpid);
		$result_select_rightpid = $query_select_rightpid->fetch_assoc();
		$pic = $result_select_rightpid['P_Name'];
		
		$sql_select_rightari = "select A_Title from articleinfo where A_AID = '$artid'";
		$query_select_rightari = $mysqli->query($sql_select_rightari);
		$result_select_rightari = $query_select_rightari->fetch_assoc();
		
		$assign_right[] = array(	"id"	=>	$artid,
									"pic"	=>	$pic,
									"name"	=>	$result_select_rightari['A_Title']);
	}
	$smarty->assign("assign_right",$assign_right);/*右侧文章推广*/
	
	$sql_select_rightapp = "select P_Pushappid,P_Pushpid from pushinfo where P_Pushid >'20' and P_Pushid < '23'";
	$query_select_rightapp = $mysqli->query($sql_select_rightapp);
	while($result_select_rightapp = $query_select_rightapp->fetch_assoc()){
		$app_pid = $result_select_rightapp['P_Pushpid'];
		$app_id = $result_select_rightapp['P_Pushappid'];

		$sql_select_rightapppid = "select P_Name from pictureinfo where P_PID = '$app_pid'";
		$query_select_rightapppid = $mysqli->query($sql_select_rightapppid);
		$result_select_rightapppid = $query_select_rightapppid->fetch_assoc();
		$apppic = $result_select_rightapppid['P_Name'];
		
		$sql_select_rightappname = "select A_Apptrackname from appinfo where A_Apptrackid = '$app_id'";
		$query_select_rightappname = $mysqli->query($sql_select_rightappname);
		$result_select_rightappname = $query_select_rightappname->fetch_assoc();
		
		$assign_rightapp[] = array(	"id"	=>	$app_id,
									"pic"	=>	$apppic,
									"name"	=>	$result_select_rightappname['A_Apptrackname']);
	}
	$smarty->assign("assign_rightapp",$assign_rightapp);/*右侧APP推广*/

	$sql_app_rank = "select * from appinfo where A_Appprice = '免费' order by A_Appdate desc limit 0,10";
	$query_app_rank = $mysqli->query($sql_app_rank);
	while($result_app_rank = $query_app_rank->fetch_assoc()){
		$assign_apprank1[] = array(	"id"	=>	$result_app_rank['A_Apptrackid'],
									"name"	=>	$result_app_rank['A_Apptrackname'],
									"icon"	=>	$result_app_rank['A_Appicon'],
								);
	}
	for($m=0;$m<10;$m++){
		$assign_apprank[] = array(	"num"	=>	$m+1,
									"id"	=>	$assign_apprank1[$m][id],
									"name"	=>	$assign_apprank1[$m][name],
									"icon"	=>	$assign_apprank1[$m][icon],
								);
	}
	$smarty->assign("assign_apprank",$assign_apprank);/*免费排名*/
	
	
	//底部
	$sql_select_bottom = "select * from siteinfo";
	$query_select_bottom = $mysqli->query($sql_select_bottom);
	$count_info = $query_select_bottom->num_rows;
	while($result_select_bottom = $query_select_bottom->fetch_assoc()){
		$assign_site[] = array( "id"	=>	$result_select_bottom['S_SID'],
								"info"	=>	$result_select_bottom['S_Name']);
	}
	$bottom = $assign_site[4][info];
	
	//左侧
	$sql_select_listpush = "select * from pushinfo where P_Pushid >22 and P_Pushid <29";
	$query_select_listpush = $mysqli->query($sql_select_listpush);
	while($result_select_listpush = $query_select_listpush->fetch_assoc()){
		$pushappid = $result_select_listpush['P_Pushappid'];
		$pushapppid = $result_select_listpush['P_Pushpid'];
		$sql_select_listpushapp = "select A_Apptrackname from appinfo where A_Apptrackid = '$pushappid'";
		$query_select_listpushapp = $mysqli->query($sql_select_listpushapp);
		$result_select_listpushapp = $query_select_listpushapp->fetch_assoc();
		$listpushname = $result_select_listpushapp['A_Apptrackname'];
		
		$sql_select_listpushpic = "select * from pictureinfo where P_PID = '$pushapppid'";
		$query_select_listpushpic = $mysqli->query($sql_select_listpushpic);
		$result_select_listpushpic = $query_select_listpushpic->fetch_assoc();
		$name = $result_select_listpushpic['P_Name'];
		
		$assign_listpush[] = array(	"id"	=>	$pushappid,
									"name"	=>	$listpushname,
									"path"	=>	"/images/".$name.".png",
									);
	}
	$smarty->assign("assign_listpush",$assign_listpush);//底部APP推荐
	
	$sql_select_newstop5 = "select A_AID,A_Title,A_CID from articleinfo where A_CID='1' order by A_date desc limit 0,5";
	$query_select_newstop5 = $mysqli->query($sql_select_newstop5);
	while($result_select_newstop5 = $query_select_newstop5->fetch_assoc()){
		$assign_newstop5[] = array(	"id"		=>	$result_select_newstop5['A_AID'],
								"category"	=>	$result_select_newstop5['A_CID'],
								"title"		=>	$result_select_newstop5['A_Title']
								);
	}
	$smarty->assign("assign_newstop5",$assign_newstop5);/*新闻前五篇*/
	
	$url = $_SERVER['REQUEST_URI'];
	$url_arr = parse_url($url);
	parse_str($url_arr['query'],$url_arr);
	$id = $url_arr[id];
	
	$sql_select_app = "select * from appinfo where A_Apptrackid = '$id'";
	$query_select_app = $mysqli->query($sql_select_app);
	if($result_select_app = $query_select_app->fetch_assoc()){
		$assign_icon = $result_select_app['A_Appicon'];
		$assign_trackname = $result_select_app['A_Apptrackname'];
		$assign_artistname = $result_select_app['A_Appartistname'];
		$assign_desc = $result_select_app['A_Appdesc'];
		$assign_language = $result_select_app['A_Applanguage'];
		$assign_date = $result_select_app['A_Appreleasedate'];
		$assign_filesize = $result_select_app['A_Appfilesize'];
		$assign_price = $result_select_app['A_Appprice'];
		$assign_countuser = $result_select_app['A_Appcountratinguser'];
		$assign_rating = $result_select_app['A_Apprating'];
		$assign_version = $result_select_app['A_Appversion'];
		$assign_count = $result_select_app['A_Appcount'];
		$assign_download = $result_select_app['A_Appdownload'];
		$assign_jailbreak = $result_select_app['A_AppJailbreak'];
		$assign_userratingcount = $result_select_app['A_Appcountratinguser'];
		$assign_trackid = $id;
		
		$kid = $result_select_app['A_Appkid'];
		$kid_explode = explode(",",$kid);
		$kid_count = count($kid_explode)-1;
		$kname_id = $kid_explode[$kid_count];
		$sql_kname = "select K_Name from keywordinfo where K_KID = '$kname_id'";
		$query_kname = $mysqli->query($sql_kname);
		$result_kname = $query_kname->fetch_assoc();
		$assign_category = $result_kname['K_Name'];
		foreach($kid_explode as $key => $value){
			$value = $kid_explode[$key];
			$sql_select_tag = "select * from keywordinfo where K_KID = '$value' and K_tags != '0'";
			$query_select_tag = $mysqli->query($sql_select_tag);
			while($result_select_tag = $query_select_tag->fetch_assoc()){
				for($i=0;$i<count($kid_explode);$i++){
					$tagname[$i] .= "<a href='article_list.php?page=1&id=&kw=".$result_select_tag['K_KID']."' target='_blank'>".$result_select_tag['K_Name']."</a>  ";
					$assign_tagname = array(	"info"	=>	$tagname[$i]);
				}
			}
		}
		
		$artist_name = $assign_artistname;
		$sql_select_artist = "select * from appinfo where A_Appartistname = '$artist_name' and A_Apptrackid != '$id'";
		$query_select_artist = $mysqli->query($sql_select_artist);
		while($result_select_artist = $query_select_artist->fetch_assoc()){
			$assign_other[] = array(	"id"	=>	$result_select_artist['A_Apptrackid'],
										"icon"	=>	$result_select_artist['A_Appicon'],
										"name"	=>	$result_select_artist['A_Apptrackname']);
		}
		$smarty->assign("assign_other",$assign_other);
		
		$pid = $result_select_app['A_Apppid'];
		$pid_explode = explode(",",$pid);
		$x = 0;
		foreach($pid_explode as $key => $value){
			$value = $pid_explode[$key];
			$sql_select_picture = "select * from pictureinfo where P_PID = '$value'";
			$query_select_picture = $mysqli->query($sql_select_picture);
			$picture_count = count($query_select_picture->num_rows);			
			while($result_select_picture = $query_select_picture->fetch_assoc()){
				for($y=0;$y<$picture_count;$y++){
					$pic_url[$y] = $result_select_picture['P_Url'];
					$assign_picurl[] = array(	"id"	=>	$x,
												"url"	=>	$result_select_picture['P_Url']);
					$x++;
				}
			}
		}
		$smarty->assign("assign_picurl",$assign_picurl);
		
		$sql_site_info = "select * from siteinfo where S_SID = '5'";
		$query_site_info = $mysqli->query($sql_site_info);
		while($result_site_info = $query_site_info->fetch_assoc()){
			$assign_footer[] = array(	"id"	=>	$result_site_info['S_SID'],
										"info"	=>	$result_site_info['S_Name'],
									);
		}
		$assign_appinfo = array($assign_icon,$assign_trackname,$assign_category,$assign_version,$assign_tagname,$assign_artistname,$assign_desc,$assign_date,$assign_language,$assign_filesize,$assign_price,$assign_countuser,$assign_rating,$assign_count,$assign_download,$assign_jailbreak,$assign_userratingcount,$assign_trackid,$assign_footer[0][info],);
		$smarty->assign("assign_appinfo",$assign_appinfo);
		$smarty->display("app.html");
	}else{
		$smarty->display("header.html");
		$smarty->display("404.html");
		$smarty->display("footer.html");
	}
?>